Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Support

Pages: 1 2 [3] 4 5 ... 58
31
MySQL / Re: Module MySQL Overview
« on: July 07, 2017, 05:34:20 pm »
I'm not sure but sending the port number as a string may be causing a problem.

My guess is at this point you're getting a CR_CONN_HOST_ERROR  response error message.

Update

My guess was correct and not passing the port number as a string allowed me to connect to your remote MySQL server with the Script BASIC extension module.

Code: Script BASIC
  1. include mysql.bas
  2. dbh =  mysql::RealConnect("sql8.freemysqlhosting.net","sql8183953","N9yUkvribn","sql8183953",3306)
  3. PRINT "Host info is: ",mysql::GetHostInfo(dbh),"\n"
  4.  


jrs@jrs-laptop:~/sb/examples/test$ scriba mysql_remote.sb
Host info is: sql8.freemysqlhosting.net via TCP/IP
jrs@jrs-laptop:~/sb/examples/test$


Here is an example of querying the MySQL information_schema tables.

Code: Script BASIC
  1. IMPORT mysql.bas
  2. dbh =  mysql::RealConnect("sql8.freemysqlhosting.net","sql8183953","N9yUkvribn","sql8183953",3306)
  3. mysql::query(dbh,"SELECT * FROM INFORMATION_SCHEMA.TABLES")
  4. WHILE mysql::FetchHash(dbh,tbls)
  5.   FOR x = 0 TO UBOUND(tbls) STEP 2
  6.     PRINT tbls[x]," - ",tbls[x+1],"\n"
  7.   NEXT
  8.   PRINTNL
  9. WEND
  10. mysql::Close(dbh)
  11.  

32
MySQL / Re: Module MySQL Overview
« on: July 06, 2017, 06:08:16 pm »
Many MySQL servers don't allow external connections due to abuse and resource utilization trying to access it by brute force.

I would try accessing the server with Excel / ODBC just to make sure you have access rights, If all is good there, we can dig a little deeper why the SB extension module is returning an extension error.

33
General Discussions / Re: help: upload files to FTP using cURL
« on: June 09, 2017, 02:24:36 am »
Would SYSTEM be a better choice?

34
General Discussions / Re: help: upload files to FTP using cURL
« on: May 27, 2017, 06:15:34 pm »
Quote
ScriptBasic v2.0

That version was before my time and over 15 years old. Please install the current 2.2 Inno Windows install of Script BASIC.

Did you catch my point about using unescaped Windows path names? Try using / instead.


35
General Discussions / Re: help: upload files to FTP using cURL
« on: May 23, 2017, 11:02:33 pm »
Code: Script BASIC
  1.  
  2. Import "c:\scriptbasic\include\curl.bas"
  3.  

I'm supprised that Script BASIC is even loading the curl.bas file with the non-escaped \ you're using.

Have you tried using Script BASIC's CHDIR to define your working directory?

36
General Discussions / Re: Linux Virtual Machine
« on: May 03, 2017, 08:17:09 pm »
Glad to hear you figured out what the problem was. Script BASIC variables being typeless until use can trip you up if not careful.


37
General Discussions / Re: Linux Virtual Machine
« on: May 03, 2017, 04:27:28 am »
Are you using the latest Inno based Windows install curl module?

Out of memory is a catch all error in extension modules as the developers didn't take the time to describe the actual error properly.  I'm slowly rewriting the distributed extension modules in C BASIC for readability, updating libraries and cleanup. Most all of the extension modules I've done are in C BASIC.






38
What's New / Re: Script BASIC Windows 32 bit - Download Available
« on: April 24, 2017, 06:54:13 pm »
I'm glad Script BASIC found a home in your toolbox of languages.

Keep us in the loop as your projects unfold.

39
What's New / Re: Script BASIC Windows 32 bit - Download Available
« on: April 22, 2017, 03:43:15 am »
How are things going in general with Script BASIC? Are you having fun yet?  :)

40
What's New / Re: Script BASIC Windows 32 bit - Download Available
« on: March 03, 2017, 04:22:22 am »
Hopefully others will give Script BASIC a try and share their experience. You can lead a horse to water ...



41
What's New / Re: Script BASIC Windows 32 bit - Download Available
« on: March 01, 2017, 08:34:05 pm »
Quote
And yet SB is the only one of the lot that does what I want it to do in both a straightforward AND a timely manner.

There has been few if any projects I have done that required using a compiler rather than an interpreter. If I have a CPU intensive function, I just write a C extension module and use it seamlessly with SB.

42
What's New / Re: Script BASIC Windows 32 bit - Download Available
« on: February 28, 2017, 04:59:44 pm »
I released Script BASIC for Windows 32 bit  on Valentines day. No one other than you showed any love. I think I'll focus my efforts on IoT and Linux instead. The problem when there are over 100 variations of BASIC.



43
What's New / Re: Script BASIC Windows 32 bit - Download Available
« on: February 27, 2017, 12:26:00 am »
I'm going to wait until I can see what the interest level for Script BASIC on Windows is. With Microsoft putting all their efforts into the cloud, Windows may not be the best use of my time.

44
What's New / Re: Script BASIC Windows 64 bit ?
« on: February 26, 2017, 02:35:52 am »
I haven't had a chance to do much with the 32-bit install yet (real life intrudes) but it is both blisteringly fast, and a very easy install. I have seen no problems at all with what little I have done.

Good to hear and at least it's something.

Quote
Given that I am running windows 7 Pro 64-bit on a moderately scaled workstation:

I think that I would only bother with a 64-bit version if it were available for the other operating systems, and if there were some genuine advantage to a 64-bit version - such as speed, extended precision maths, storage etc. Game writers might have more to say about that, though. I'm not sure what advantages might be available with a 64-bit install.

Going forward, I can see backward compatability with 32-bit processors going the way 16-bit support in Windows has been dropped (and woe betide anyone who actually has 8-bit software for a PC  ??? ) - and at that time, I guess a 64-bit version will be necessary.

I already have a 64 bit version of Script BASIC built. I just don't have it in an Inno install file format.

Quote
While I would like to install a 64-bit version, right now, the 32-bit version of SB is perfectly sufficient. (mind you, all of my development is using 32-bit software - VB6, mainly).

If it wasn't for Dave Zimmer's work with COM / VB6 with Script BASIC, I probably wouldn't have created the Windows 32 bit Inno install version and kept my focus on Linux.

Quote
My bottom line: I believe that a 64-bit SB install will be necessary at some point, so now is probably a good time to get started - before it becomes the only version acceptable under Windows 11, 12 or whatever. No rush.

See above.

45
What's New / Re: Script BASIC Windows 64 bit ?
« on: February 25, 2017, 10:25:36 pm »
I was thinking of putting together a Windows 64 bit Script BASIC Inno install but I haven't received any feedback on the 32 bit version I have already posted. Would you put forth the effort if you were me?

Pages: 1 2 [3] 4 5 ... 58