Hi All
I've created a dts on SQL Server 2000 that pulls data from Oracle. I have 4 different connections to 4 different Oracle servers via 'Microsoft OLE DB Provider For Oracle'. The transformation tasks run one after the other, upon successful completion.
Testing the connections works fine...
...search one day!
The problem was with the pre-compile of the nested proc. My bit parameter sql read a bit like this:
If @ReturnResultSet=1 Select * From Table1
but during the precompile it 'readied' the field structure of the object Table1 which ultimately ended up as being the dataset in...
I have a Proc, let's call it 'spB'. Within that proc I have a nested Proc ('spA') which goes off and inserts some records into a few tables then based on a Bit parameter decides whether to return a recordset.
Now when I execute spA from spB I pass 'False' as the paramter for spA so it will not...
I'm new to SQL Server and am not sure whether it is possible to link to an Oracle table using SQL Server. I previously used Microsoft Access through which it is dead easy to link to Oracle. I have found out how to import data via SQL Server, but not linking.
Can anyone help?
Thom
I am having trouble changing a field in a table from text to long integer. So far I have:
dim DB As Database
Dim tdf As TableDef
Dim fld As Field
Set DB = CurrentDb()
Set tdf = DB.TableDefs("tbl_VisitData")
Set fld = tdf.Fields("Org ID")
I can't find a way to update...
That doesn't seem to work. The only way I can get it to work at the moment is by using the send keys function. ie:
listbox.SetFocus
SendKeys "{DOWN}"
Which is a bit messy, but its all I've got at the moment!
Thanks for your input,
Thom
Simple or not I am having a problem with listboxes.
All I want to do is have the first (or indeed any) row highlighted when the form containing the listbox is opened.
Can anyone help?
Thanks,
Thom
In one piece of code I have output a text file to the root of the C:\ drive.
Later on I want to knowwhether that txt file is there. Apart from opening it is there a way I can test to see if it is there?
Any help, greatly appreciated,
Thom.
2 queries really.
I have the following simple code to produce a table in code with a unique primary key:
Set tdf = DB.CreateTableDef(strTempSR)
Set fld = tdf.CreateField("ID", dbInteger, 3)
tdf.Fields.Append fld
DB.Execute "CREATE UNIQUE INDEX PrimaryKey ON " & strTempSR &...
Everytime I click on a hyperlink on a form the web toolbar appears. I have turnedall menus, toolbars etc off on the start up of the database but it does not help.
Any ideas?
I have used the following code in the OnKeyDown event of a txtbox to run a command held on the click event of a button (the outcome of which sets the focus to the txtbox):
If KeyCode = 13 Then cmdLogIn_Click
The code works fine when the button itself is pressed (the txtbox aquires the focus)...
Thanks Frink,
I have been experimanting with creating tables on the fly (with the tbl name = date (ddmmyyyyhhnnss)) and think I'll go with that.
Thanks for your advice,
Thom.
I have created a Q&A Search Form in Access 97 (its a lot like the Windows Explorer Search screen). It was built to sit on the users PC and delete and append into temporary tables.
Now it is required to sit on an NT server and be accessed by many different users. In effect it has to become multi...
The one i had in mind is for a Q&A Search Engine I am currently assembling. All of the Q&A data adhears to a particular 'type' (eligibility for example). In order for the user to search using the type function it would make sense to only let them select the 'types' that are available.
Thanks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.