I'm somewhat bemused by this error. Not because I'm getting it but because it only occurs the first time I try running my code.
I have the following ADO connection that runs on the Form_Load() as soon as I start my app from VB.
cn.ConnectionString = "Provider=MSDASQL.1;DSN=Paradox Files;DBQ=C:\CrewTrack\Data"
cn.Open
I have a second form which is started up from a menu item which has the following code in the Form_Load() event to fill a list box based on a recordset from the previous connection.
strSQL = "SELECT EMPNO, NAME FROM EMPL WHERE NAME <> '' ORDER BY NAME ASC"
rsEmp.Open strSQL, frmFront.cn, adOpenStatic, adLockReadOnly
The first time that I run this program and try opening the second form I get the error:
Run-time error '-2147467259 (80004005)':
[Microsoft][ODBC Paradox Driver] Selected collating sequence not supported by the operating system.
However, if I choose to end and then start it again it works fine. It only seems to happen the first time.
Any ideas??
